package com.his.his_system.mapper;

import com.his.his_system.domain.DzmHisSupplier;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author 冯心愿
* @description 针对表【dzm_his_supplier(供应商表)】的数据库操作Mapper
* @createDate 2023-07-06 14:28:06
* @Entity com.his.his_system.domain.DzmHisSupplier
*/
public interface DzmHisSupplierMapper extends BaseMapper<DzmHisSupplier> {

    @Select("select * from dzm_his_supplier su ,dzm_his_hospital ho where su.hospital_id = ho.id")
    List<DzmHisSupplier> xianshi();

    @Delete("DELETE from DzmHisSupplier where sid=#{sid}")
    int deletee(String sid);
}




